Help Center -> System Settings -> Database management

## Database Management

The homepage of the system shows database backup history. The system allows database backup, database initialization and database restoration.
1. Database backup path configuration:
Select [Database backup path configuration] in the [Server Controller] operation menu, the edit interface appears.
Click [Browse] to select the backup path, click [Save] to save the selection and quit.
Note:
(1) In software installation process, it will prompt to set the database backup path. If you haven’t set the backup path, the operation of backup database can’t be executed (The server for other computer to access, need to set the backup path in the server firstly).
(2) Proposal that the database backup path and the present system installed path not be under the same disk. Don’t set the path to the root of a disk, and no blanket permitted.
2. Backup database:
Periodically backup the system’s database to ensure data security. To use the backed up data, just restore the data.
(1) Click [Backup database] to enter the backup interface;
(2) Select from backup now, scheduled backup and cancel scheduled backup. Scheduled backup can set backup every several hours since a start time;
(3) Click [OK]. For Backup now, it will return after backup. For scheduled backup, it will backup as scheduled.
Note:
(1) After database backing up, the value under “Whether backup successful” will change to “Yes” or “No”. “Yes” indicates database backing up successfully, otherwise, the back up operation is failed.
(2) We recommended backing up the database after you create the personnel file, device information or part of access control level settings.
(3) The system not support to backup Oracle database, if you need to backup, please uses the specific Oracle backup tools.
3. Restore Database:
Select [Restore Database] in the [Server Controller] operation menu, the following interface appears.
Click [Browse] to select a successfully backed up database from the backup database list, click [Start] begin the database restoration.
4. Initialize database:
Initialize database is to restore data to system initialization status. Initialized data in the database will be deleted. Please operate with care.
Click [Initialize database] to enter edit interface, select one or several datasheets to initialize, and click [OK] to complete initialization and return.
For example:
Select to initialize access level: After selection, it will initialize access control time periods, access control holidays and access levels. All contents on these three pages will restore initial statuses;
Select to initialize door settings: After selection, it will initialize all interlock settings, anti-passback settings, linkage settings, first-card opening settings, and multi-card opening settings (including personnel group of multi-card verification);
Select to initialize events: After selection, it will initialize all real-time monitoring records;
Select to initialize access control: After selection, it will initialize all settings and information in the access control system, including the above three items, and only reserve system default settings;
Select to initialize devices: After selection, it will initialize all device information in the system (including access control). If the device is an access control panel, corresponding device parameters and door information will be deleted.
Note: If the device is still in normal use, please initialize database cautiously, especially when involving access level-related departments and personnel, access levels, door settings, areas, devices, users and roles. It is recommended that if there are still devices in use after database initialization, the user shall [Synchronize all data] for the setting to avoid unexpected errors.